﻿CREATE TABLE [dbo].[CPU] (
    [CPUID]        VARCHAR (50)     NOT NULL,
    [Manufacturer] VARCHAR (50)     NULL,
    [Status]       VARCHAR (50)     NULL,
    [ClockSpeed]   VARCHAR (50)     NULL,
    [ServerID]     UNIQUEIDENTIFIER NULL,
    [Cores]        INT              NULL,
    CONSTRAINT [PK_CPU] PRIMARY KEY CLUSTERED ([CPUID] ASC),
    CONSTRAINT [FK_CPU_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

